Daily Cash Balance
The Daily Cash Balance report gives the user a quick look into an account's daily cash balance. This real time view can give business managers a better tool for cash management.
Getting a Daily Cash Balance Update
Activating
This functionality is activated at the Authority Class level.
- Access the Authority Class menu (menu option NAV 2).
- Enter a W in the appropriate Opt field of the Authority Class you want to work with.
- Press Enter to access the following screen which provides the ability to grant or revoke access at the Navigator application level. Enter a W to drill down into the Accounting options.
- By default, the Daily Cash Balance functionality is delivered in an inactive status. To activate it, enter a G and press Enter.
Getting a Daily Cash Balance Update
- Open up Navigator and select the Daily Cash Balance option under the Accounting heading.
- Enter a Company, Cash Account# and Posting Period and click Search.
- The Posting Period year can only be the current or prior year.
- The Beginning Balance at the top of the table is the ending balance from the prior posted period. Beginning balances are calculated by:
- Sum all Current Debit values through the month prior to the Posting Period entered to obtain the total debits.
- Sum all Current Credit values through the month prior to the Posting Period entered to obtain the total credits.
- Subtract the total credits from the total debits to obtain the total amount for the period.
- Add the total amount for the period to the Current BF Debit or Credit value (only one will be populated).
- Each day's ending balance is calculated and shown in the Ending Balance column.
- Click the drill down arrow to the right of a date to see the details of the transaction.
The Company is validated against the Company File and the Cash Account drop down menu is populated from the Bank Code Maintenance (menu option ACT 113).
The same steps apply if the posting period is in a prior year; however history debits and credits are used.
